package com.ruoyi.project.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.project.domain.entity.ProjectPay;
import com.ruoyi.project.domain.entity.ProjectPhase;
import com.ruoyi.project.domain.query.ProjectPayQuery;
import com.ruoyi.project.domain.query.ProjectPhaseQuery;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ProjectPhaseMapper extends BaseMapper<ProjectPhase> {
    List<ProjectPhase> getList(ProjectPhaseQuery query);



    @Select("select DISTINCT project_no FROM hcitx_performance.project_attachment where attachment_type in('4','5') and del_flag = 0")
    List<String> selectDistinctProjectNoByPhaseId(@Param("phaseId") String phaseId);

}
